interview

home / developersection / interviews / define connected and disconnected data access in ado.net?

Ask Question

Define connected and disconnected data access in ADO.NET?

Pushpendra Singh 2316 25-Oct-2010
db2 db2 
Updated on 21-Sep-2020
Pushpendra Singh

Other

Message
Can you answer this question?
Answer

1 Answers

Rajesh Goswami

Rajesh Goswami

08-Nov-2010
Connected data access through the DataReader objects of data provider. This object requires exclusive use of the connection object. It can provide fast and forward-only data access. It doesn't allow editing.
 Disconnected data access is achieved through the DataAdapter object. This object establishes connection, executes the command, load data in the DataSet. The dataset works independent of database. It contains data in the memory and can edit the data. The changes in the data can be transmitted to the database using Update method of DataAdapter object. 
MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy